-- SELECT TOP 500 * FROM renault_2013_data ORDER BY YIL * 12 + AY DESC

ALTER TABLE renault_2013_data ALTER COLUMN MODEL VARCHAR(32) NULL
ALTER TABLE renault_2013_data ADD SATICI NVARCHAR(40) NULL
ALTER TABLE renault_verbatim ALTER COLUMN Content nvarchar(4096) NULL

--SELECT YIL, COUNT(YIL) FROM renault_qvo_data GROUP BY YIL
--delete from renault_qvo_data WHERE YIL < 2009

--SELECT * FROM renault_data WHERE AY = 11

--UPDATE renault_2013_data SET MODEL = 'CAPTUR' WHERE MARKA = 'Renault' AND IID % 8 = 1 -- 1762
--UPDATE renault_2013_data SET MODEL = 'GRAND SCENIC' WHERE MARKA = 'Renault' AND IID % 8 = 2 -- 1791
--UPDATE renault_2013_data SET MODEL = 'MEGANE HB' WHERE MARKA = 'Renault' AND IID % 8 = 3 -- 1799
--UPDATE renault_2013_data SET MODEL = 'MEGANE SPORT TOURER' WHERE MARKA = 'Renault' AND IID % 8 = 4 -- 1713
--UPDATE renault_2013_data SET MODEL = 'YENI CLIO' WHERE MARKA = 'Renault' AND IID % 8 = 5 -- 1762

--UPDATE renault_2013_data SET MODEL = 'KANGOO EXPRESS' WHERE MARKA = 'Renault' AND IID % 8 = 6 -- 1766
--UPDATE renault_2013_data SET MODEL = 'YENI KANGOO EXPRESS' WHERE MARKA = 'Renault' AND IID % 8 = 7 -- 1762
--UPDATE renault_2013_data SET MODEL = 'YENI MASTER' WHERE MARKA = 'Renault' AND IID % 8 = 0 -- 1799

--UPDATE renault_2013_data SET MODEL = 'DOKKER CAMLI' WHERE MARKA = 'Dacia' AND IID % 3 = 1 -- 2267
--UPDATE renault_2013_data SET MODEL = 'LOGGY' WHERE MARKA = 'Dacia' AND IID % 3 = 2 -- 2161
--UPDATE renault_2013_data SET MODEL = 'SANDERO' WHERE MARKA = 'Dacia' AND IID % 3 = 0 -- 2215
